[dbo].[BAEImisProductGetAllByType]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEImisProductGetAllByType
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@ProductType
varchar(10)
10
SQL Script
create
procedure
[dbo]
.
[BAEImisProductGetAllByType]
@ProductType
as
varchar
(
10
)
AS
SELECT
*
FROM
Product
WHERE
PROD_TYPE
=
@ProductType
GO
Uses
[dbo].[Product]
dbo
[dbo].[BAEImisProductGetAllByType] [dbo].[BAEImisProductGetAllByType]